Main
Giovanni Colitti
Experienced Data Scientist with a strong background in Economics, currently building tools to drive insights and visibility into cloud infrastructure at Apple.
Education
National Taiwan University
M.S. in Agricultural Economics (4.0 GPA)
Taipei, Taiwan
2018
California State University, Channel Islands
B.A. in Economics (3.8 GPA)
Camarillo, CA
2016
Experience
Data Scientist
Apple - Cloud Services (contract)
Remote
2022 - Current
- Contributed to the development of a Kubernetes cost model for the leadership team, wrote an API to facilitate the extraction of cost information from the model, and designed a Shiny app for visualization and counterfactual analysis.
- Automated tooling for customer chargebacks and built tools to project Kubernetes quota clawbacks, streamlining reporting and planning processes.
- Developed and presented interactive Kubernetes usage reports, enhancing internal customer visibility and efficiency.
- Led the optimization of BigQuery table schemas and pipelines for trillions of rows of data, reducing query costs by over 90%.
Senior Business Intelligence Analyst
Fieldin
Remote
2020 - 2022
- Developed a Shiny app for interactive creation of visualizations and tables in PowerPoint slides, saving users hours per week as revealed by a user survey.
- Created an algorithm for counting harvest loads by analyzing distance patterns, achieving 90% prediction accuracy.
- Established a framework for estimating customer costs, aiding in strategic planning.
- Developed a Shiny app for interactive mapping of machine data and additional apps for ad hoc report creation, supporting the customer success team.
- Managed database tables serving as the backend for the apps used in customer success team’s reporting.
- Created and managed a platform for developing and publishing web applications using ShinyProxy.
Data Scientist
Grimmway
Bakersfield, CA
2018 - 2020
- Developed machine learning models to improve sales and yield forecasts by 30-50% over previous methods.
- Built a YOLO v5 object detection pipeline to generate carrot stand count estimates with 95% accuracy, dramatically decreasing costs.
- Created linear programming models to optimize planting and harvesting, maximizing yield and meeting sales demand.
- Developed an R package for time-series cross-validation and Shiny apps for visualization and optimization.
- Analyzed research trial data, performed sample size calculations, and provided spatial sampling recommendations to the agronomy team.
Selected Research
Do Concealed Firearms Decrease Crime? An Analysis Using Active Concealed Firearm License Data in the United States
Used a unique dataset on county-level concealed firearms permits and applied two-stage least squares estimation to show that concealed firearms do not decrease crime.
N/A
2018
Do HEVs Cause More Cyclist & Pedestrian Injuries?
Used logit model & large UK accident-level dataset to show that quieter electric vehicles significantly increase pedestrian accidents net of other covariates including speed limit and urbanization. Also used Bayesian methods (MCMC) to estimate the posterior distribution and check for non-normality in estimates.
N/A
2018
Effect of Hurricane Morakot on Agricultural Prices in Taiwan
Used a difference-in-differences (DiD) event study model and a large transaction-level dataset to quantify the casual effect of Hurricane Morakot on vegetable prices in Taiwan, adding weight to the literature that claims weather is oftentimes the most important driver of local agricultural prices.
N/A
2018
Academic Honors and Awards
Thesis Competition First Place Prize
Master’s thesis presentation competition first place winner.
N/A
2018
Taiwan Ministry of Education Scholarship
Merit scholarship for post-graduate studies in Taiwan.
N/A
2016
Program Honors in Economics
Selected by CSUCI Economics Department faculty for outstanding achievement.
N/A
2016
Wang Family Scholarship
Merit scholarship for international study in Taiwan & Mainland China.
N/A
2014
President’s Scholarship
Highest scholastic achievement award in CSU system; only handful awarded annually.
N/A
2012
Disclaimer
Last updated on 2024-01-22.